Interview Questions

1. 1.How many JDBC driver types does Sun define?

Options:

a. One

b. Two

c. Three

d. Four

e. five

Reveal Answer

2. 2.JDBC stands for:

Options:

a. Java Database Connectivity

b. Java Database Components

c. Java Database Control

d. None of the above is correct.

Reveal Answer

3. 3.Which JDBC driver Type(s) can be used in either applet or servlet code?

Options:

a. Both Type 1 and Type 2

b. Both Type 1 and Type 3

c. Both Type 3 and Type 4

d. Type 4 only

Reveal Answer

4. 4.________ is an open source DBMS product that runs on UNIX, Linux and Windows.

Options:

a. MySQL

b. JSP/SQL

c. JDBC/SQL

d. Sun ACCESS

Reveal Answer

5. 5.What MySQL property is used to create a surrogate key in MySQL?

Options:

a. UNIQUE

b. SEQUENCE

c. AUTO_INCREMENT

d. None of the above -- Surrogate keys are not implemented in MySQL.

Reveal Answer

6. 6.Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?

Options:

a. Type 1 only

b. Type 2 only

c. Both Type 3 and Type 4

d. All of Type 1, Type 2, Type 3 and Type 4

Reveal Answer

7. 7.Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

Options:

a. Type 1

b. Type 2

c. Type 3

d. Type 4

Reveal Answer

8. 8.Which JDBC driver Types are for use over communications networks?

Options:

a. Type 3 only

b. Type 4 only

c. Both Type 3 and Type 4

d. Neither Type 3 nor Type 4

Reveal Answer

9. 9.Which of the following is not a component/class of JDBC API?

Options:

a. Statement

b. ResultSet

c. SQLException

d. ConnectionPool

Reveal Answer

10. 10.Which of the following gives out the connection to the database and implements the protocol for transferring the query and result between client and database?

Options:

a. DriverManager

b. JDBC driver

c. Connection

d. Statement

Reveal Answer

11. 11. Which of the following type of JDBC driver, is also called Type 1 JDBC driver?

Options:

a. JDBC-ODBC Bridge plus ODBC driver

b. Native-API, partly Java driver

c. JDBC-Net, pure Java driver

d. Native-protocol, pure Java driver

Reveal Answer

12. 12.Which of the following represents a regular SQL statement in JDBC?

Options:

a. Statement

b. PreparedStatement

c. CallableStatement

d. None of the above.

Reveal Answer

13. 13.Which of the following is correct about JDBC 4.0?

Options:

a. DataSet Implementation of SQL using annotations.

b. SQL XML support.

c. Both of the above.

d. None of the above.

Reveal Answer

14. 14.Which of the following is correct about savepoint?

Options:

a. A savepoint marks a point that the current transaction can roll back to.

b. Instead of rolling all of the changes back, a savepoint can be choosen to roll back only some of them.

c. Both of the above.

d. None of the above.

Reveal Answer

15. 15.When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement?

Options:

a. true

b. false

Reveal Answer

16. 16.Which of the following means that the ResultSet can be both read and updated?

Options:

a. ResultSet.CONCUR_READ_ONLY

b. ResultSet.CONCUR_UPDATABLE

c. ResultSet.READ_ONLY

d. ResultSet.UPDATABLE

Reveal Answer

17. 17. Which of the following step establishes a connection with a database?

Options:

a. Import packages containing the JDBC classes needed for database programming.

b. Register the JDBC driver, so that you can open a communications channel with the database.

c. Open a connection using the DriverManager.getConnection () method.

d. Execute a query using an object of type Statement.

Reveal Answer

18. 18.Prepared statements are more secure because they use bind variables, which can prevent SQL injection attack.

Options:

a. true

b. false

Reveal Answer

19. 19.Where is metadata stored in MySQL?

Options:

a. In the MySQL database metadata

b. In the MySQL database metasql

c. In the MySQL database mysql

d. None of the above is correct.

Reveal Answer

20. 20. Which of the following required to be closed to close database operations?

Options:

a. ResultSet

b. Statement

c. Connection

d. All of the above.

Reveal Answer

21. 21.Which of the following is correct about ResultSet class of JDBC?

Options:

a. ResultSet holds data retrieved from a database after you execute an SQL query using Statement objects.

b. It acts as an iterator to allow you to move through its data.

c. The java.sql.ResultSet interface represents the result set of a database query.

d. All of the above.

Reveal Answer

22. 22.In which of the following type of ResultSet, the cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created?

Options:

a. ResultSet.TYPE_FORWARD_ONLY

b. ResultSet.TYPE_SCROLL_INSENSITIVE

c. ResultSet.TYPE_SCROLL_SENSITIVE

d. None of the above.

Reveal Answer

23. 23.How to remove event handlers

Options:

a. Remove ()

b. off ()

c. change ()

d. clear ()

Reveal Answer

24. 24.Which of the following is correct syntax to catch specific type of error and redirect to View.

Options:

a. [HandleError (Exception = typeof (ApplicationException), View = "Error")]

b. [HandleError (Exception = ApplicationException, View = "Error")]

c. [HandleError (ExceptionType = typeof (ApplicationException), View = "Error")]

d. [HandleError (ExceptionType = ApplicationException, View = "Error")]

Reveal Answer

25. 25.If attach multiple event handler in a single function

Options:

a. Yes

b. No

Reveal Answer

26. 26. Which of the following type of JDBC driver should be used if your Java application is accessing multiple types of databases at the same time?

Options:

a. Type 1

b. Type 2

c. Type 3

d. Type 4

Reveal Answer

27. 27.Which is keyboard events

Options:

a. click

b. mouseenter

c. keypress

d. keyup

Reveal Answer

28. 28.Which of the following type of JDBC driver is typically used for development and testing purposes only?

Options:

a. Type 1

b. Type 2

c. Type 3

d. Type 4

Reveal Answer

29. 29.In web.config &ltcustomErrors mode="RemoteOnly" defaultRedirect="/Errors/Index"/&gt is used to

Options:

a. Redirect the user to Custom error page only if the request is sent from a remote client

b. Redirect the user to Custom error page only if the request is sent from a local client

c. Redirect the user to Custom error page only if the request is sent from a either remote or local client

d. Redirect the user to always to Custom error page irrespective of from where the request is sent.

Reveal Answer

30. 30.How can we destroy a cookie already present on client machine?

Options:

a. Response.Cookies.Remove

b. Request.Cookies.Remove

c. Add to response another cookie with expired date

d. Add to request another cookie with expired date

Reveal Answer

31. 31.Which of the following is efficient than statement due to pre-compilation of SQL?

Options:

a. Statement

b. PreparedStatement

c. CallableStatement

d. None of the above.

Reveal Answer

32. 32.What is the difference between Hover and Mouse over?

Options:

a. Mouseover allows you to specify an optional function to use for the mouseout event

b. Hover allows you to specify an optional function to use for the mouseout event

c. both

d. none

Reveal Answer

33. 33.Which of the following are required properties of OutputCache attribute?

Options:

a. Duration

b. VaryByParam

c. VaryByHeader

d. Location

Reveal Answer

34. 34.Which object is for managing Cookies in ASP.NET?

Options:

a. HttpCookie

b. Cookie

c. RequestCookie

d. ResponseCookie

Reveal Answer

35. 35.Which of the following is correct about batch process?

Options:

a. Batch Processing allows you to group related SQL statements into a batch.

b. Batch Processing allows you to submit batch of SQL statements with one call to the database.

c. Both of the above.

d. None of the above.

Reveal Answer

36. 36.Out of String or a java.sql.Clob, which has best performance when used to manipulate data from database?

Options:

a. String

b. java.sql.Clob

Reveal Answer

37. 37.Which of the following is true? Options:

Options:

a. All cookies can be added to an object of type HttpCookie and same object should be added to Response.Cookies collection

b. All cookies can be added to an object of type HttpCookie and same object should be added to Request.Cookies collection

c. For each cookie we have to create a separate object of HttpCookie and add to Request.Cookies collection

d. For each cookie we have to create a separate object of HttpCookie and add to Response.Cookies collection

Reveal Answer

38. 38.Which of the following is correct about CallableStatement?

Options:

a. Used when you want to access the database stored procedures.

b. The CallableStatement interface can accept runtime input parameters.

c. Both of the above.

d. None of the above.

Reveal Answer

39. 39.Can we use both JQuery and Ajax together

Options:

a. Yes

b. No

Reveal Answer

40. 40.Tell the name of jQuery method which is used to perform asynchronies HTTP Request

Options:

a. jQuery. Ajax()

b. Ajax. JQuery()

c. $.Ajax()

d. Ajax.$()

Reveal Answer

41. 41. Which of the following attributes of a cookie can be read from a cookie in Request.Cookies

Options:

a. Value

b. Domain

c. Path

d. Expires

e. All of the above

Reveal Answer

42. 42.A connected RowSet Object is permanent in nature. It doesn't terminate until the application is terminated.

Options:

a. true

b. false

Reveal Answer

43. 43.Domain, Path, Expires and secure attributes are included with a cookie in the request.

Options:

a. True

b. False

Reveal Answer

44. 44.What is the use of jQuery load() method?

Options:

a. The load() method lodes on the server

b. The load() method lodes on the server

c. Both

d. None

Reveal Answer

45. 45.Which of the following is true about JDBC?

Options:

a. The JDBC API is an API to access different relational databases.

b. You use it to access relational databases without embedding a dependency on a specific database type in your code.

c. JDBC stands for Java DataBase Connectivity.

d. All of the above.

Reveal Answer

46. 46.What are the goals of Ajax?

Options:

a. Reduced web server hits

b. Reduced Network load

c. Interactive user Interface

d. All

Reveal Answer

47. 47.Which of the following is correct about Statement class of JDBC?

Options:

a. Statement encapsulates an SQL statement which is passed to the database to be parsed and compiled.

b. Statement encapsulates an SQL statement which is passed to the database to be planned and executed.

c. Both of the above.

d. none of the above.

Reveal Answer

48. 48.Which of the following gives out the connection to the database and implements the protocol for transferring the query and result between client and database?

Options:

a. DriverManager

b. JDBC driver

c. Connection

d. Statement

Reveal Answer

49. 49.Which of the following type of JDBC driver should be used if your Java application is accessing multiple types of databases at the same time?

Options:

a. Type 1

b. Type 2

c. Type 3

d. Type 4

Reveal Answer

50. 50.Which of the following is correct about JDBC?

Options:

a. JDBC architecture decouples an abstraction from its implementation.

b. JDBC follows a bridge design pattern.

c. Both of the above.

d. None of the above.

Reveal Answer

51. 51.Which of the following is correct about Class.forName() method call?

Options:

a. This method dynamically loads the driver's class file into memory, which automatically registers it.

b. This method is preferable because it allows you to make the driver registration configurable and portable.

c. Both of the above.

d. None of the above.

Reveal Answer

Interview Questions and Answer

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources